package servlet;
import servlet.Connections;
import java.sql.*;
import java.util.*;
import java.io.*;

public class ExportData 
{
	Connections conn=new Connections();
	ResultSet rs=null;
	Statement stmt=null;
	String query="select * from customerlead";
	ArrayList getCustData=new ArrayList();
	
	/*public static void main(String ar[])
	{
		ExportData ed=new ExportData();
		ed.getCustomerData();
	}*/
	public ArrayList getCustomerData()
	{
		try
		{
			stmt=conn.getConnection().createStatement();
			rs=stmt.executeQuery(query);
			
			//for(int i=1;i<=11;i++)
			//{
				while(rs.next())
				{
					getCustData.add(rs.getString(1));
					getCustData.add(rs.getString(2));
					getCustData.add(rs.getString(3));
					getCustData.add(rs.getString(4));
					getCustData.add(rs.getString(5));
					getCustData.add(rs.getString(6));
					getCustData.add(rs.getString(7));
					getCustData.add(rs.getString(8));
					getCustData.add(rs.getString(9));
					getCustData.add(rs.getString(10));
					getCustData.add(rs.getString(11));

			    }
				//System.out.println(getCustData);
		//	}	
		}
		catch(Exception e)
		{
		
		}
		return getCustData;
	}	

}
